﻿package com.ostrich.manpower.controller;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import com.base.util.HtmlUtil;
import com.base.web.BaseAction;
import com.ostrich.manpower.bean.TostHrBaseinfo;
import com.ostrich.manpower.bean.TostHrDepartinfo;
import com.ostrich.manpower.bean.TostHrMealaddinfo;
import com.ostrich.manpower.bean.TostHrSalaryinfo;
import com.ostrich.manpower.common.ImportUtil;
import com.ostrich.manpower.common.OstDateUtils;
import com.ostrich.manpower.service.impl.TostHrBaseinfoService;
import com.ostrich.manpower.service.impl.TostHrDepartinfoService;
import com.ostrich.manpower.service.impl.TostHrMealaddinfoService;
import com.ostrich.manpower.service.impl.TostHrSalaryinfoService;

/**
 * ClassName: Controller <br/>
 * date: 2013-5-9 下午03:07:38 <br/>
 * 
 * @author wangyinan
 * @version
 */
@Controller
@RequestMapping("/tostHrMealaddinfo")
public class TostHrMealaddinfoController extends BaseAction {
private final static Logger log = Logger.getLogger(TostHrMealaddinfoController.class);

	// Servrice start
	@Autowired(required = false)
	// 自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrMealaddinfoService<TostHrMealaddinfo> tostHrMealaddinfoService;
	
	@Autowired(required = false)
	TostHrSalaryinfoService<TostHrSalaryinfo> tostHrSalaryinfoService;
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrBaseinfoService<TostHrBaseinfo> tosthrbaseinfoservice; 
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrDepartinfoService<TostHrBaseinfo> tosthrdepartinfoservice; 
	/**
	 * ilook 首页
	 * 
	 * @param url
	 * @param classifyId
	 * @return
	 */
	@RequestMapping("/list")
	public ModelAndView list(TostHrMealaddinfo tostHrMealaddinfo,HttpServletRequest request) throws Exception {
		Map<String, Object> context = getRootMap();
		List<TostHrMealaddinfo> dataList = tostHrMealaddinfoService.queryByList(tostHrMealaddinfo);
		// 设置页面数据
		context.put("dataList", dataList);
		return forword("manpower/tabTostHrMealaddinfo", context);
	}
	
	//查询部门名称
		@RequestMapping("/queryDepartId")
	         public void  queryDepartId(HttpServletResponse response){
			    List<TostHrDepartinfo> dataList =tosthrdepartinfoservice.queryDapart();
				HtmlUtil.writerJson(response, dataList);
		}
	

	/**
	 * json 列表页面
	 * 
	 * @param url
	 * @param classifyId
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/dataList")
	public void dataList(TostHrMealaddinfo tostHrMealaddinfo,
			HttpServletResponse response) throws Exception {
		List<TostHrMealaddinfo> dataList = tostHrMealaddinfoService
				.queryByList(tostHrMealaddinfo);
//		for (TostHrMealaddinfo ud : dataList) {
//			// 这里可以做数据封装到对象中。
//		}
		// 设置页面数据
		Map<String, Object> jsonMap = new HashMap<String, Object>();
		jsonMap.put("total", tostHrMealaddinfo.getPager().getRowCount());
		jsonMap.put("rows", dataList);
		HtmlUtil.writerJson(response, jsonMap);
	}

	/**
	 * 添加或修改数据
	 * 
	 * @param url
	 * @param classifyId
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/save")
	public void save(TostHrMealaddinfo bean, HttpServletResponse response,HttpServletRequest request)
			throws Exception {
			//添加或跟新的日期格式
		bean.setHmeMonth(OstDateUtils.getDateByMonth(bean.getHmeMonth()));
		if (bean.getId() == null) {
			tostHrMealaddinfoService.add(bean);
		} else {
			tostHrMealaddinfoService.update(bean);
		}
		sendSuccessMessage(response, "保存成功~");
	}

	@RequestMapping("/getId")
	public void getId(Integer id, HttpServletResponse response)
			throws Exception {
		Map<String, Object> context = getRootMap();
		TostHrMealaddinfo bean = tostHrMealaddinfoService.queryById(id);
		if (bean == null) {
			sendFailureMessage(response, "没有找到对应的记录!");
			return;
		}
		context.put(SUCCESS, true);
		context.put("data", bean);
		HtmlUtil.writerJson(response, context);
	}

	@RequestMapping("/delete")
	public void delete(Integer[] id, HttpServletResponse response)
			throws Exception {
		tostHrMealaddinfoService.delete(id);
		sendSuccessMessage(response, "删除成功");
	}

	@RequestMapping(value = "/upload", method = RequestMethod.POST)
	public ModelAndView upload(HttpServletRequest request,
			HttpServletResponse response, ModelMap model) throws IOException {
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		// 得到上传的文件
		MultipartFile mFile = multipartRequest.getFile("excelPath");
		// 得到上传服务器的路径
		String path = request.getSession().getServletContext()
				.getRealPath("/WEB-INF/upload/");
		// 得到上传的文件的文件名
		String filename = mFile.getOriginalFilename();
		InputStream inputStream = mFile.getInputStream();
		byte[] b = new byte[1048576];
		int length = inputStream.read(b);
		path += "\\" + filename;
		// 文件流写到服务器端
		FileOutputStream outputStream = new FileOutputStream(path);
		outputStream.write(b, 0, length);
		inputStream.close();
		outputStream.close();
		request.setAttribute("path", path);
		request.setAttribute("month", request.getParameter("hmeMonth"));
		return new ModelAndView("forward:/tostHrMealaddinfo/upimport.do");
	}

	@RequestMapping(value = "/upimport")
	public ModelAndView upimport(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		Map<String, Object> context = getRootMap();
		String filepath = (String) request.getAttribute("path");
		String month = (String) request.getAttribute("month");
			
		try {
			InputStream fis = new FileInputStream(filepath);
			HSSFSheet sh = ImportUtil.getSheet(fis);
			
			String times12 = month.substring(0,4);
			String times11 = month.substring(5,7);

			String hs = times12 + times11;

				if(!hs.equals(hs) && hs!=null){		
				}
							  
			String msg=tostHrMealaddinfoService.setMealBySheet(sh,hs);
			msg=(msg!=null&&msg.length()>0)?"但是有异常数据未导入："+msg:"";
			request.setAttribute("success", "您已经导入成功请查看!");
			request.setAttribute("msg", "您已经导入成功请查看。"+msg);
			request.setAttribute("url", request.getContextPath() + "/tostHrMealaddinfo/list.do");
		} catch (Exception e) {
			e.printStackTrace();
			  
			request.setAttribute("msg", "导入失败，请查看xls文件是否格式正确");
		}
		return forword("penmsg", context);
		
	}
	
}
